{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Stage to Production"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Stage to Production","index":0,"n_rows":37,"n_cols":4,"rows_kept":37,"merged":[[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,1,4,3],[5,1,5,3]],"flags":["formulas_cached_only"]}
[]
["WORKTerra"]
["Check List for Migrating Company From Stage To Production"]
[]
["Date:","2017-12-06"]
["Resource  Name:","Ashwin Wankhede"]
["Company  Name:","Jefferson County"]
["SR.No","Steps","Responsible Person","Status"]
[1,"Take Backup of the Company to Be Migrated","Dev","Done"]
[2,"Check Onlineenrollment database for getting the correct database name","Dev","Done"]
[3,"Copy Generated Files (sequence-bar etc), Images,Stylesheet and Forms(File Server) in one folder on Production","Dev","Done"]
[4,"Zip this folder, Upload it to Production Server Shared Path","Dev","Done"]
[5,"Copy Generated Files,Images,Stylesheet in respective folders.  Make sure this is done on All Web Servers","Dev","Done"]
[6,"Forms are copied on File Server in respective folders","Dev","Done"]
[7,"Add one entry in OnlineenrollmentDB.Company table. Set IS active = 1  [Script to Add company entry to make st n prod sync.sql]","Dev","Done"]
[8,"Create new database name it as per Stage, restore Stage database copy","Dev","Done"]
[9,"delete database level trigger ie protect_db and TR_MaintainArchivalDD from DB server   ","Dev","Done"]
[10,"Execute “Arch delete .Sql” on main company [cluster] db to delete Archival table , schema and trigger. Please dont  Execute it on reporting server database","Dev","Done"]
[11,"Execute integrated Production Script on this database               (All build script generated from production branch)                     Dont Execute any Script of OnlineEnrollment","Dev","Done"]
[12,"Make proper company module mapping","QA"]
[13,"Save EDS and theme","QA"]
[14,"Login to the site with Partner/Broker/Employee role and make sure all pages are displayed","QA"]
[15,"Dashboard configuration","QA"]
[16,"Set “Read_commited_snapshot on” for database","Dev","Done"]
[17,"ON CLUSTER Only \nFrom Code base \\WT\\Production Branch\\Change Data Capture\\Production & LB \nFINAL COMBINED SCRIPT ENABLE CDC – PRODUCTION.sql","Dev","Done"]
[18,"Execute on Both servers                                                               exec [dbo].[OES_SP_Update_View_Employee_FormData]","Dev","Done"]
[19,"ON CLUSTER Only                                                                            Need to Give rights to SA user for this company to  Dashboard [Default Rights to Dashboard while company migrating from stage to production.sql]","Dev","Done"]
[20,"Summary counter job verification                                     [System HOme page counters correction.sql]","Dev","Done"]
[21,"update BasetemplateID for 834 wizard                           [Correction for 834 wizard.sql]","Dev","Done"]
[22,"If there is new theme with company then we need to copy All theme assets [select * from wt.Themes where Name1 like '%sbm%']","Dev","Done"]
[23,"Check if any Additional Fields Exist in \"AdditionalFieldInfo\", If Exists need to copy the Entries from OnlineEnrollment.dbo.Memberfieldrights from Stage to Production    Query to check Additonal Field: [SELECT * From OnlineEnrollment.dbo.Memberfieldrights where companyid = 111]","Dev","Done"]
[24,"Change the UserId of production equivalent to stage userid.","Dev","Done"]
[25,"Add company ID in service configuration file:\nServiceScheduler.exe.config    [Not between 12:30 to 5:30] ","Dev","Done"]
[26,"Set report server data source connection string to new data source","Dev","Done"]
[27,"Rights to IsAllCompaniesSelected=1 users","Dev","Done"]
[28,"Eligibility Migration","Dev","Pending"]
[29,"Restart Import Export Service               Verify Time with Export Team","Dev","Pending"]